Release 10.1A: OpenEdge Data Management:
Database Administration

Auditing tables

Enabling your database for auditing creates seven new tables in your database meta-schema. Table 9–1 briefly describes each of the tables. The details on the fields and indexes of each of these tables are discussed in OpenEdge Getting Started: Core Business Services .

Table 9–1: Auditing meta-schema tables 

Table name	Description	Archived
_aud-audit-data	This table contains the audit data records. All events are stored in this table.	Yes.
_aud-audit-data-value	This table is a child table of the _aud-audit-data table, and contains records for each field change data event.	Yes.
_aud-audit-policy	This table contains named audit policies. If multiple policies are active, the aggregation of the policies is applied, and the highest level of auditing will be applied if a conflict exists between policies.	No.
_aud-event	This table contains the definitions for all supported OpenEdge and user-defined audit events and their event ids. All event ids up to 32,000 are reserved. You can create custom application events with ids greater than 32,000.	Yes.
_aud-event-policy	This table contains policy settings for events associated with policies.	No.
_aud-field-policy	This table contains field level auditing settings associated with a named policy.	No.
_aud-file-policy	This table contains table level auditing settings associated with a named policy.	No.